Introduction
This is our R Notebook, showing the steps we took to complete the Final Project for CS 329E. This notebook includes step-by-step instructions on how to reproduce our project. To obtain our data, we used data.world.
R Configuration
Below we display our sessionInfo().
sessionInfo(package=NULL)
Data Description
The data was found on “Dr. John Rasp’s Statistics Website” (http://www2.stetson.edu/~jrasp/data.htm). It is a subset of the data from College Scorecard, a Department of Education website that gives data on various variables regarding tuition, costs and school performance.
Cleaning Data
Here’s our ETL file to clean our data set.
source("../01 Data/R_ETL.CollegeScorecard.R")
Cleaned up Data Download
Cleaned data can be downloaded from Data.world as a .csv file. Because the dataset is so large, we filtered to only show some rows.
Hosting User: jlee Database: S17 DV Final Project Dataset Name: CollegeScorecard.csv
Download Link: https://query.data.world/s/dv5dl8q1jx2qb3d3bd2976b9d
source("../01 Data/Accessdataworld.R")
Tableau / Tableau Action Generated Visualizations
Descriptions: Full size static .pngs of the tableau visualizations. Refer to visualization captions for individual descriptions.
Tableau generated barcharts. 
Tableau generated ID sets. 
Shiny Visualization and Published Application
Description: Full size static .pngs of the Shiny application, as well as a link to the live published version.
Published Link: https://frannyfang.shinyapps.io/Barchart1/
Barchart1
LS0tDQp0aXRsZTogIjxjZW50ZXI+PGI+R2xvYmFsIFNoaXBtZW50cyBEYXRhPC9iPjwvY2VudGVyPiINCmF1dGhvcjogIjxjZW50ZXI+PGI+WXUtQ2hpYW8gRmFuZywgRWxpemFiZXRoIEtpbSwgU2V1bmcgSG9vbiBMZWUsIE9ybGFuZG8gUmVhdGVndWk8L2I+PC9jZW50ZXI+Ig0Kb3V0cHV0Og0KICBodG1sX2RvY3VtZW50Og0KICAgIHRvYzogeWVzDQogIGh0bWxfbm90ZWJvb2s6DQogICAgdG9jOiB5ZXMNCi0tLQ0KDQojKipJbnRyb2R1Y3Rpb24qKg0KVGhpcyBpcyBvdXIgUiBOb3RlYm9vaywgc2hvd2luZyB0aGUgc3RlcHMgd2UgdG9vayB0byBjb21wbGV0ZSB0aGUgRmluYWwgUHJvamVjdCBmb3IgQ1MgMzI5RS4gVGhpcyBub3RlYm9vayBpbmNsdWRlcyBzdGVwLWJ5LXN0ZXAgaW5zdHJ1Y3Rpb25zIG9uIGhvdyB0byByZXByb2R1Y2Ugb3VyIHByb2plY3QuIFRvIG9idGFpbiBvdXIgZGF0YSwgd2UgdXNlZCBkYXRhLndvcmxkLiANCg0KIyoqUiBDb25maWd1cmF0aW9uKioNCkJlbG93IHdlIGRpc3BsYXkgb3VyIHNlc3Npb25JbmZvKCkuDQoNCmBgYHtyIHNlc3Npb25JbmZvfQ0Kc2Vzc2lvbkluZm8ocGFja2FnZT1OVUxMKQ0KYGBgDQoNCiMqKkRhdGEgRGVzY3JpcHRpb24qKg0KVGhlIGRhdGEgd2FzIGZvdW5kIG9uICJEci4gSm9obiBSYXNwJ3MgU3RhdGlzdGljcyBXZWJzaXRlIiAoaHR0cDovL3d3dzIuc3RldHNvbi5lZHUvfmpyYXNwL2RhdGEuaHRtKS4gSXQgaXMgYSBzdWJzZXQgb2YgdGhlIGRhdGEgZnJvbSBDb2xsZWdlIFNjb3JlY2FyZCwgYSBEZXBhcnRtZW50IG9mIEVkdWNhdGlvbiB3ZWJzaXRlIHRoYXQgZ2l2ZXMgZGF0YSBvbiB2YXJpb3VzIHZhcmlhYmxlcyByZWdhcmRpbmcgdHVpdGlvbiwgY29zdHMgYW5kIHNjaG9vbCBwZXJmb3JtYW5jZS4NCg0KIyoqQ2xlYW5pbmcgRGF0YSoqDQpIZXJlJ3Mgb3VyIEVUTCBmaWxlIHRvIGNsZWFuIG91ciBkYXRhIHNldC4NCg0KYGBge3J9DQpzb3VyY2UoIi4uLzAxIERhdGEvUl9FVEwuQ29sbGVnZVNjb3JlY2FyZC5SIikNCmBgYA0KDQojKipDbGVhbmVkIHVwIERhdGEgRG93bmxvYWQqKg0KQ2xlYW5lZCBkYXRhIGNhbiBiZSBkb3dubG9hZGVkIGZyb20gRGF0YS53b3JsZCBhcyBhIC5jc3YgZmlsZS4gQmVjYXVzZSB0aGUgZGF0YXNldCBpcyBzbyBsYXJnZSwgd2UgZmlsdGVyZWQgdG8gb25seSBzaG93IHNvbWUgcm93cy4NCg0KSG9zdGluZyBVc2VyOiBqbGVlPC9icj4NCkRhdGFiYXNlOiBTMTcgRFYgRmluYWwgUHJvamVjdDwvYnI+DQpEYXRhc2V0IE5hbWU6IENvbGxlZ2VTY29yZWNhcmQuY3N2DQoNCkRvd25sb2FkIExpbms6IGh0dHBzOi8vcXVlcnkuZGF0YS53b3JsZC9zL2R2NWRsOHExangycWIzZDNiZDI5NzZiOWQNCg0KYGBge3J9DQpzb3VyY2UoIi4uLzAxIERhdGEvQWNjZXNzZGF0YXdvcmxkLlIiKQ0KYGBgDQoNCg0KIyoqU2lkZSBieSBTaWRlIFNoaW55IGFuZCBUYWJsZWF1IFZpc3VhbGl6YXRpb25zKioNCioqRGVzY3JpcHRpb25zOioqIFJlZmVyIHRvIHZpc3VhbGl6YXRpb24gY2FwdGlvbnMgZm9yIGluZGl2aWR1YWwgZGVzY3JpcHRpb25zLjwvYnI+PC9icj4NCjxiPkJveHBsb3Q6IEF2ZXJhZ2UgQ29zdCBvZiBBdHRlbmRhbmNlIGZvciBUeXBlIG9mIFNjaG9vbDwvYj4gPC9icj48L2JyPg0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0F2ZXJhZ2UgQ29zdCBvZiBBdHRlbmRhbmNlIGZvciBUeXBlIG9mIFNjaG9vbCBCb3hwbG90IChUYWJsZWF1KS5wbmcpeyB3aWR0aD00OSUgfQ0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0JveHBsb3QucG5nKXsgd2lkdGg9NDklIH0NClRoZXNlIGJveHBsb3RzIChUYWJsZWF1IGxlZnQsIFNoaW55IHJpZ2h0KSBkZmRkZjwvYnI+PC9icj4NCg0KPGI+SGlzdG9ncmFtOiBTQVQgQXZlcmFnZXMgZm9yIFVuaXZlcnNpdGllczwvYj4gPC9icj48L2JyPg0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL1NBVF9BVkcgSGlzdG9ncmFtIChUYWJsZWF1KS5wbmcpeyB3aWR0aD00OSUgfQ0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0hpc3RvZ3JhbS5wbmcpeyB3aWR0aD00OSUgfQ0KVGhlc2UgaGlzdG9ncmFtcyAoVGFibGVhdSBsZWZ0LCBTaGlueSByaWdodCkgZGZkZGY8L2JyPjwvYnI+DQoNCjxiPlNjYXR0ZXJwbG90OiBJbnN0cnVjdGlvbmFsIEV4cGVuZGl0dXJlcyB2cy4gTmV0IHR1aXRpb248L2I+IDwvYnI+PC9icj4NCiFbXSguLi8wMyBWaXN1YWxpemF0aW9ucy9TY2F0dGVyIFBsb3QgKFRhYmxlYXUpLnBuZyl7IHdpZHRoPTQ5JSB9DQohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvU2NhdHRlcnBsb3QucG5nKXsgd2lkdGg9NDklIH0NClRoZXNlIHNjYXR0ZXJwbG90cyAoVGFibGVhdSBsZWZ0LCBTaGlueSByaWdodCkgZXhwbG9yZSB0aGUgY29ycmVsYXRpb24gYmV0d2VlbiBJbnN0cnVjdGlvbmFsIGV4cGVuZGl0dXJlcyBwZXIgZnVsbC10aW1lIGVxdWl2YWxlbnQgc3R1ZGVudCBhbmQgTmV0IHR1aXRpb24gcmV2ZW51ZSBwZXIgZnVsbC10aW1lIGVxdWl2YWxlbnQgc3R1ZGVudC4NCjwvYnI+PC9icj4NCg0KDQo8Yj5Dcm9zc3RhYiAxOiBCTEFCTEFMQkxBPC9iPiA8L2JyPjwvYnI+DQohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvQ3Jvc3N0YWIgKyBLUEkgdyBTZXQgMSAoVGFibGVhdSkucG5nKXsgd2lkdGg9NDklIH0NCiFbXSguLi8wMyBWaXN1YWxpemF0aW9ucy9rcGkxLnBuZyl7IHdpZHRoPTQ5JSB9DQpUaGVzZSBjcm9zc3RhYnMgKFRhYmxlYXUgbGVmdCwgU2hpbnkgcmlnaHQpIHh4eHgNCjwvYnI+PC9icj4NCg0KPGI+Q3Jvc3N0YWIgMjogQkxBQkxBTEJMQTwvYj4gPC9icj48L2JyPg0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0Nyb3NzdGFiICsgS1BJIHcgU2V0IDIgKFRhYmxlYXUpLnBuZyl7IHdpZHRoPTQ5JSB9DQohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMva3BpMi5wbmcpeyB3aWR0aD00OSUgfQ0KVGhlc2UgY3Jvc3N0YWJzIChUYWJsZWF1IGxlZnQsIFNoaW55IHJpZ2h0KSB4eHh4DQo8L2JyPjwvYnI+DQoNCjxiPk1hcCAxOiBCTEFCTEFMQkxBPC9iPiA8L2JyPjwvYnI+DQohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvQ3Jvc3N0YWIgTWFwIDEgKFRhYmxlYXUpLnBuZyl7IHdpZHRoPTQ5JSB9DQohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvTWFwMS5wbmcpeyB3aWR0aD00OSUgfQ0KVGhlc2UgbWFwcyAoVGFibGVhdSBsZWZ0LCBTaGlueSByaWdodCkgeHh4eA0KPC9icj48L2JyPg0KDQo8Yj5NYXAgMjogQkxBQkxBTEJMQTwvYj4gPC9icj48L2JyPg0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0Nyb3NzdGFiIE1hcCAyIChUYWJsZWF1KS5wbmcpeyB3aWR0aD00OSUgfQ0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL01hcDIucG5nKXsgd2lkdGg9NDklIH0NClRoZXNlIG1hcHMgKFRhYmxlYXUgbGVmdCwgU2hpbnkgcmlnaHQpIHh4eHgNCjwvYnI+PC9icj4NCg0KDQo8Yj5CYXJjaGFydDogQkxBQkxBTEJMQTwvYj4gPC9icj48L2JyPg0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0JhcmNoYXJ0IChUYWJsZWF1KS5wbmcpeyB3aWR0aD0zMCUgfQ0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0JhcmNoYXJ0IElEIFNldHMgTWFwIChUYWJsZWF1KS5wbmcpeyB3aWR0aD0zMCUgfQ0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0JhcmNoYXJ0IElEIFNldHMgTWFwIChUYWJsZWF1KS5wbmcpeyB3aWR0aD0zMCUgfQ0KVGhlc2UgYmFyY2hhcnRzIChUYWJsZWF1IGxlZnQsIFNoaW55IHJpZ2h0KSB4eHh4DQo8L2JyPjwvYnI+DQoNCg0KIyoqVGFibGVhdSAvIFRhYmxlYXUgQWN0aW9uIEdlbmVyYXRlZCBWaXN1YWxpemF0aW9ucyoqDQoqKkRlc2NyaXB0aW9uczoqKiBGdWxsIHNpemUgc3RhdGljIC5wbmdzIG9mIHRoZSB0YWJsZWF1IHZpc3VhbGl6YXRpb25zLiBSZWZlciB0byB2aXN1YWxpemF0aW9uIGNhcHRpb25zIGZvciBpbmRpdmlkdWFsIGRlc2NyaXB0aW9ucy4NCg0KVGFibGVhdSBnZW5lcmF0ZWQgYmFyY2hhcnRzLiA8L2JyPjwvYnI+DQohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvTWFwMS5wbmcpPGJyPjxicj48YnI+DQoNClRhYmxlYXUgZ2VuZXJhdGVkIElEIHNldHMuPC9icj48L2JyPg0KIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL01hcDEucG5nKTxicj48YnI+PGJyPg0KDQojKipTaGlueSBWaXN1YWxpemF0aW9uIGFuZCBQdWJsaXNoZWQgQXBwbGljYXRpb24qKg0KKipEZXNjcmlwdGlvbjoqKiBGdWxsIHNpemUgc3RhdGljIC5wbmdzIG9mIHRoZSBTaGlueSBhcHBsaWNhdGlvbiwgYXMgd2VsbCBhcyBhIGxpbmsgdG8gdGhlIGxpdmUgcHVibGlzaGVkIHZlcnNpb24uPGJyPg0KDQpQdWJsaXNoZWQgTGluazo8L2JyPg0KaHR0cHM6Ly9mcmFubnlmYW5nLnNoaW55YXBwcy5pby9CYXJjaGFydDEvPC9icj4NCg0KQmFyY2hhcnQxDQohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvTWFwMS5QTkcpeyB3aWR0aD0yMCUgfTwvY2VudGVyPg0K